package com.fan.dao.user;

import com.fan.pojo.Role;
import com.fan.pojo.User;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface UserDao {


    public User getLoginUser(Connection connection, String userCode) throws SQLException;
    public int updatePwd(Connection connection,int id,String password) throws SQLException;
    public int getUserCount(Connection connection,String username,int userRole) throws SQLException;
    public List<User> getUserList(Connection connection,String userName,int userRole,int currentPageNo,int pageSize) throws SQLException;
    public int add(Connection connection, User user) throws SQLException;
    public int deleteUserById(Connection connection, Integer delId) throws SQLException;
    public User getUserById(Connection connection, String id) throws SQLException;
    public boolean updateUserById(Connection connection,String id, String userName, String gender, String birthday, String phone, String address, String userRole) throws SQLException;
}





























